<?php
class M_DbTable_CruiseItinerary extends Apps_Db_Table_Abstract {
	protected $_name = 'cruise_itinerary';

	const STATUS_ACTIVE  	= 1;
	const STATUS_INACTIVE  	= 0;
	const STATUS_DELETED  	= -1;

	//LIST
	public function getList () {
		$q = $this->_db
					->select()
					->from($this->_name, null)
					->where('status =?', self::STATUS_ACTIVE)
					->order($this->_name . '.en_code')
					->columns(array('id'			=> 'id',
									'code'			=> 'code',
									'en_code'		=> 'en_code',
									'title'			=> 'title',
									'en_title'		=> 'en_title',
									'description'	=> 'description',
									'created_date'  => 'created_date'));
		return $q;
	}
}